﻿CREATE TABLE [dbo].[CLM_837I_2000C_Patient]
(
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[Patient_HL01_PatientHierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_HL02_PatientHierarchicalParentIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_HL03_PatientHierarchicalLevelCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_HL04_PatientHierarchicalChildCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_PAT01_IndividualRelationshipCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM101_EntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM102_EntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM103_PatientLastName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM104_PatientFirstName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM105_PatientMiddleName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM107_PatientNameSuffix] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM108_PatientIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_NM109_PatientPrimaryIdentifier] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N301_PatientAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N302_PatientAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N401_PatientCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N402_PatientStateCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N403_PatientPostalCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_N404_PatientCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_DMG02_PatientGenderCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_DMG03_PatientBirthDate] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_REF01_PropertyAndCasualtyRefIdQualifier] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Patient_REF02_PropertyCasualtyClaimNumber] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST01_EDIMessageType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Subscriber_HL01_HierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSMessageID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


